package com.hfzy.ihk.web.freeswitchManage.mapper;

import com.hfzy.ihk.facade.freeswitchManage.entity.SipRegistrations;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hfzy.ihk.facade.freeswitchManage.entity.Userinfo;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author wws
 * @since 2018-12-29
 */
public interface SipRegistrationsMapper extends BaseMapper<SipRegistrations> {

    @Select("select reg_user as sipUser from registrations where reg_user =#{sipUser}")
    SipRegistrations querySipRegistrationsByUserName(String sipUser);

}
